Methods to Know COMPATIBILITY LEVEL of a Database

Question

Amanda Nunes · Answer

Post is removed by the Admin.

Samuel Fernandes · Answer

Hi Sushant ,
There are many mehods to know compatibility level I will tell one by one
  Create database School_Context
Now run any of these codes to know the compatibility levels of the newly created database named School_Contextand 
1) Use system stored procedure sp_helpdb
  EXEC sp_helpdb School_Context
It shows you two results. The first result has the column named compatibility_level that shows the value.and 
2) Use system stored procedure sp_dbcmptlevel
EXEC sp_dbcmptlevel School_Context
and 
and The result is
The current compatibility level is 120.and 
3-Use system views
  SELECT name,compatibility_levelFROM sys.databasesWHERE name='School_Context'
  and 
The result is 120
and 
and

forum

Methods to Know COMPATIBILITY LEVEL of a Database

Sushant Mishra

Can you answer this question?

2 Answers

Liked By